import cufflinks as cf
import pandas as pd
import numpy as np
import plotly.offline as py
import plotly.graph_objs as go
from IPython.display import display, Markdown, Latex
py.init_notebook_mode(connected=True)
cf.set_config_file(offline=True)
dtype = {'County': np.str,
'Employee Name': np.str,
'Job Title': np.str,
'Year': np.int64,
'Notes': np.str,
'Agency': np.str,
'Status': np.str}
def to_float(x):
try:
return float(x)
except Exception as e:
return None
converters = {'Base Pay': to_float,
'Overtime Pay': to_float,
'Other Pay': to_float,
'Benefits': to_float,
'Total Pay': to_float,
'Total Pay & Benefits': to_float}
df = pd.read_csv("data.csv.gz", compression='gzip', dtype=dtype, converters=converters)
def get_df(county, entity, year):
return df[(df['County'] == county) &
(df['Job Title'].str.contains("(?i){entity}".format(entity=entity))) &
(df['Year'] == year)]
def display_mean_salary_by_year(county, entity, year):
ga = get_df(county, entity, year).groupby(['Agency'])['Total Pay & Benefits']
ga_mean = ga.mean()
ga_mean = ga_mean.to_frame().reset_index().sort_values(by='Total Pay & Benefits', ascending=False)
ga_mean.iplot(title='{county}, {entity}, Mean Salary - {year}'.format(county=county,
entity=entity,
year=year),
x='Agency', kind='bar', filename='cufflinks/grouped-bar-chart')
display(ga.describe().sort_values(by='mean', ascending=False))
YEARS = [2016, 2015, 2014, 2013, 2012]
COUNTIES = ['San Mateo County']
ENTITIES = ['teacher', 'principal']
for county in COUNTIES:
for entity in ENTITIES:
display(Markdown('# {county}, {entity}, Mean Salary in {year_from} - {year_to}'.format(county=county,
entity=entity,
year_from=min(YEARS),
year_to=max(YEARS))))
for year in YEARS:
display_mean_salary_by_year(county, entity, year)
| count | mean | std | min | 25% | 50% | 75% | max | |
|---|---|---|---|---|---|---|---|---|
| Agency | ||||||||
| Portola Valley Elementary | 51.0 | 114308.219020 | 35249.918013 | 24441.29 | 103155.8500 | 121072.10 | 141348.2650 | 155939.98 |
| Las Lomitas Elementary | 86.0 | 112186.286860 | 34589.274925 | 17674.21 | 101644.4400 | 124789.11 | 135003.1050 | 162679.42 |
| Menlo Park City Elementary | 197.0 | 109100.831675 | 31872.646527 | 4772.96 | 93540.9600 | 120378.59 | 132307.0000 | 149728.85 |
| San Mateo Union High | 516.0 | 89637.898624 | 55348.637580 | 0.00 | 43487.9725 | 110342.98 | 136326.1075 | 177103.02 |
| Redwood City Elementary | 414.0 | 84091.860145 | 30399.758222 | 3467.76 | 66821.5800 | 90014.50 | 108050.1200 | 130262.17 |
| San Mateo County Office of Education | 98.0 | 81386.744898 | 51924.932731 | 161.00 | 34584.7500 | 87253.00 | 130387.5000 | 162407.00 |
| San Mateo-Foster City | 671.0 | 80915.340134 | 34628.192956 | 0.00 | 56369.8450 | 88089.60 | 109455.3500 | 130813.29 |
| San Carlos Elementary | 179.0 | 80820.370000 | 30054.581153 | 10515.54 | 62665.3750 | 93103.93 | 101742.9000 | 118654.71 |
| Belmont-Redwood Shores Elementary | 212.0 | 80434.726415 | 30277.630425 | 1.00 | 63843.0000 | 84095.00 | 104613.7500 | 141135.00 |
| Pacifica School District | 166.0 | 78638.991265 | 31585.521205 | 0.00 | 56373.2525 | 88943.20 | 105053.9350 | 126200.80 |
| South San Francisco Unified | 361.0 | 76595.146814 | 26264.206634 | 0.00 | 65551.0000 | 79782.00 | 96918.0000 | 127910.00 |
| Burlingame Elementary | 184.0 | 74049.296196 | 27328.244889 | 4156.15 | 54526.6300 | 77799.64 | 96986.4500 | 116783.89 |
| Bayshore Elementary | 23.0 | 71390.652174 | 24179.923018 | 23153.00 | 64017.0000 | 76141.00 | 85656.5000 | 102482.00 |
| La Honda-Pescadero Unified | 38.0 | 66914.996579 | 30181.638608 | 24.70 | 47218.5150 | 72050.93 | 87400.4625 | 124795.88 |
| count | mean | std | min | 25% | 50% | 75% | max | |
|---|---|---|---|---|---|---|---|---|
| Agency | ||||||||
| San Mateo Union High | 388.0 | 117053.419407 | 38169.116191 | 1199.06 | 97240.6825 | 129096.210 | 146170.9600 | 195573.51 |
| Menlo Park City Elementary | 210.0 | 106634.159810 | 38686.061510 | 1314.29 | 85142.0375 | 121874.850 | 136013.6300 | 152600.47 |
| Woodside Elementary | 39.0 | 105741.350000 | 32786.614038 | 35032.81 | 85672.0350 | 115348.250 | 127850.4250 | 165303.09 |
| Hillsborough City Elementary | 135.0 | 105162.210370 | 36274.898210 | 14200.68 | 82639.9600 | 117400.880 | 132841.8800 | 156858.61 |
| San Carlos Elementary | 180.0 | 83407.442056 | 27958.945131 | 466.41 | 71778.0475 | 93333.765 | 103788.5975 | 120869.68 |
| San Mateo-Foster City | 629.0 | 83212.395008 | 29649.920508 | 0.00 | 66751.6200 | 90426.970 | 106376.2700 | 130413.40 |
| Cabrillo Unified | 184.0 | 81777.165978 | 34833.832782 | 881.28 | 62324.3800 | 85248.490 | 110965.5075 | 151335.71 |
| South San Francisco Unified | 462.0 | 79156.752078 | 26248.529575 | 7958.79 | 66955.5950 | 84441.055 | 100269.8175 | 134160.62 |
| Jefferson Elementary | 352.0 | 78553.438267 | 29733.544352 | 1159.30 | 62450.7850 | 85683.545 | 101899.6775 | 130453.74 |
| Las Lomitas Elementary | 147.0 | 76413.640408 | 60059.383481 | 0.00 | 5274.0450 | 96178.840 | 131790.1800 | 164809.81 |
| Pacifica School District | 167.0 | 74941.960838 | 32807.893235 | 279.69 | 44251.4650 | 84648.410 | 102492.5250 | 124831.43 |
| Millbrae Elementary | 145.0 | 72698.632207 | 31377.970924 | 1219.43 | 42626.0000 | 78673.190 | 100827.2700 | 122979.02 |
| La Honda-Pescadero Unified | 37.0 | 72450.631351 | 33348.148371 | 66.35 | 60311.7900 | 80146.950 | 92991.6200 | 129516.80 |
| Belmont-Redwood Shores Elementary | 293.0 | 62663.578669 | 44117.376622 | 75.50 | 17713.8200 | 70308.950 | 101781.4100 | 138947.88 |
| Redwood City Elementary | 683.0 | 58250.725256 | 40445.781841 | 0.00 | 18701.5100 | 59961.680 | 97720.3450 | 127244.90 |
| Bayshore Elementary | 26.0 | 57759.400769 | 28857.414005 | 3612.80 | 34075.6750 | 65248.930 | 75227.9475 | 103615.24 |
| Burlingame Elementary | 289.0 | 52548.259758 | 39689.071425 | 0.00 | 10129.9100 | 52903.210 | 91831.6400 | 115200.73 |
| count | mean | std | min | 25% | 50% | 75% | max | |
|---|---|---|---|---|---|---|---|---|
| Agency | ||||||||
| Portola Valley Elementary | 52.0 | 105835.640962 | 37843.494669 | 19043.07 | 84528.1450 | 118646.980 | 136825.6275 | 150799.05 |
| San Mateo Union High | 416.0 | 103967.956082 | 39288.931495 | 0.00 | 79755.1200 | 116578.340 | 134148.1225 | 174815.47 |
| Menlo Park City Elementary | 186.0 | 100413.679355 | 29965.087940 | 11063.51 | 84839.6175 | 111633.745 | 122127.9225 | 155511.51 |
| Hillsborough City Elementary | 121.0 | 100334.018099 | 32384.399559 | 2340.89 | 84872.4300 | 112626.720 | 124116.3900 | 143246.43 |
| San Mateo County Office of Education | 103.0 | 87739.738835 | 39363.815048 | 395.31 | 66196.7950 | 107152.760 | 119103.0500 | 136965.99 |
| Jefferson Elementary | 332.0 | 76217.283343 | 25110.283448 | 3763.12 | 63432.5300 | 82794.685 | 95520.4375 | 119883.27 |
| Belmont-Redwood Shores Elementary | 217.0 | 74392.099355 | 30452.177747 | 3774.79 | 49936.4900 | 80745.930 | 100871.8900 | 126241.04 |
| Redwood City Elementary | 495.0 | 74273.028343 | 30093.956590 | 351.67 | 48675.1450 | 77395.720 | 99867.0950 | 121788.88 |
| Brisbane Elementary | 37.0 | 73454.801081 | 28064.801734 | 11053.65 | 50678.8100 | 85438.750 | 94788.6700 | 118708.63 |
| Pacifica School District | 165.0 | 73329.545758 | 31912.636493 | 678.11 | 44900.9200 | 83471.820 | 100356.1400 | 121840.67 |
| Ravenswood City Elementary | 197.0 | 71128.684619 | 25138.881238 | 0.00 | 56524.6700 | 73807.540 | 88427.7300 | 115228.80 |
| Millbrae Elementary | 139.0 | 71015.978201 | 30785.372272 | 17.22 | 46388.6500 | 78047.890 | 96976.9750 | 119780.36 |
| Las Lomitas Elementary | 148.0 | 69855.697703 | 53580.997176 | 160.59 | 7628.1150 | 78512.025 | 120401.0125 | 150214.89 |
| San Carlos Elementary | 166.0 | 67331.713735 | 20636.466296 | 7099.70 | 56748.8775 | 72876.010 | 81953.3250 | 92283.37 |
| Jefferson Union High | 307.0 | 67162.868013 | 36646.405483 | 787.85 | 36045.0050 | 73695.530 | 96644.9100 | 139596.81 |
| San Bruno Park Elementary | 127.0 | 67075.628976 | 22418.212869 | 10196.68 | 54798.2050 | 72355.320 | 83035.3600 | 102585.78 |
| San Mateo-Foster City | 689.0 | 66616.075849 | 39514.742097 | 0.00 | 29700.6700 | 74407.940 | 98813.2800 | 146467.25 |
| La Honda-Pescadero Unified | 39.0 | 65014.450000 | 30052.891996 | 12498.98 | 37932.8850 | 63799.980 | 91097.8600 | 111784.48 |
| Burlingame Elementary | 300.0 | 47605.959067 | 39188.397976 | 66.00 | 3930.7500 | 47564.800 | 84949.2275 | 109924.81 |
| count | mean | std | min | 25% | 50% | 75% | max | |
|---|---|---|---|---|---|---|---|---|
| Agency | ||||||||
| San Mateo Union High | 438.0 | 106746.377466 | 32364.589033 | 6441.78 | 91408.7975 | 118055.935 | 130396.8425 | 168120.68 |
| Menlo Park City Elementary | 185.0 | 105104.414703 | 30059.186691 | 24090.59 | 94554.8200 | 115788.830 | 126987.8800 | 153199.80 |
| Portola Valley Elementary | 51.0 | 100642.726078 | 32682.519865 | 27403.30 | 83698.2400 | 111475.080 | 127329.1850 | 142243.51 |
| Woodside Elementary | 42.0 | 91489.523333 | 35015.897871 | 27239.60 | 61736.5725 | 105456.310 | 119330.6000 | 153219.27 |
| Sequoia Union High | 561.0 | 90095.171961 | 42362.880521 | 137.12 | 53709.9600 | 103786.260 | 125135.6000 | 156745.76 |
| San Mateo County Office of Education | 107.0 | 86761.852991 | 43038.564355 | 172.39 | 46162.7700 | 108267.940 | 119327.4400 | 136325.97 |
| Brisbane Elementary | 31.0 | 77818.666774 | 18070.359894 | 18839.57 | 71261.1650 | 81433.830 | 87380.9600 | 105451.17 |
| San Carlos Elementary | 161.0 | 76820.162298 | 25046.030843 | 10598.42 | 63564.8700 | 82375.410 | 97196.7100 | 112622.01 |
| Redwood City Elementary | 449.0 | 75288.017951 | 25819.079886 | 1834.92 | 60152.6300 | 81916.510 | 96344.2400 | 116783.84 |
| Cabrillo Unified | 183.0 | 75205.049508 | 36026.067850 | 110.00 | 49244.5700 | 87243.610 | 104155.5400 | 142403.74 |
| Belmont-Redwood Shores Elementary | 205.0 | 73109.070537 | 30021.014470 | 2665.76 | 59466.5200 | 80115.690 | 97904.8800 | 123762.26 |
| Jefferson Elementary | 305.0 | 71644.482197 | 21574.008981 | 4925.83 | 58902.8600 | 77942.150 | 88039.2900 | 109289.78 |
| San Mateo-Foster City | 602.0 | 71214.452957 | 26121.344440 | 583.81 | 57438.8500 | 77823.610 | 91047.5850 | 112736.83 |
| Las Lomitas Elementary | 143.0 | 70782.838811 | 54023.507918 | 95.44 | 7836.5850 | 81882.300 | 122727.0400 | 152121.77 |
| South San Francisco Unified | 468.0 | 70256.048098 | 24695.864975 | 958.73 | 60398.0325 | 75477.730 | 89180.5775 | 122537.33 |
| Pacifica School District | 161.0 | 70103.760311 | 28779.303537 | 4844.49 | 53541.3900 | 78631.270 | 93947.8200 | 114053.43 |
| Millbrae Elementary | 126.0 | 69823.920714 | 27954.430841 | 5995.26 | 52522.7425 | 79981.635 | 94162.4125 | 112745.96 |
| Burlingame Elementary | 174.0 | 68961.492241 | 26729.159614 | 16394.88 | 46036.7975 | 74302.805 | 91756.5450 | 112808.86 |
| Ravenswood City Elementary | 213.0 | 65991.920563 | 26802.787115 | 2211.88 | 41526.0000 | 71886.560 | 85880.9700 | 111852.33 |
| Hillsborough City Elementary | 200.0 | 57354.300750 | 48936.884226 | 67.50 | 2530.3700 | 55736.105 | 108284.9700 | 140377.22 |
| Jefferson Union High | 320.0 | 55105.377406 | 37056.504768 | 3.64 | 16885.6475 | 64265.885 | 86367.0700 | 125814.87 |
| La Honda-Pescadero Unified | 42.0 | 51679.879524 | 30051.522997 | 1745.12 | 26156.1975 | 53969.835 | 74093.1175 | 108244.30 |
| Bayshore Elementary | 33.0 | 39379.459394 | 31633.674839 | 135.31 | 5022.8000 | 33913.540 | 63776.9000 | 97785.69 |
| count | mean | std | min | 25% | 50% | 75% | max | |
|---|---|---|---|---|---|---|---|---|
| Agency | ||||||||
| Redwood City Elementary | 1.0 | 106291.190000 | NaN | 106291.19 | 106291.1900 | 106291.190 | 106291.1900 | 106291.19 |
| Portola Valley Elementary | 51.0 | 103730.362745 | 36416.987905 | 12196.40 | 82261.1500 | 116476.300 | 131327.4600 | 147461.64 |
| San Mateo Union High | 448.0 | 102353.300915 | 32984.911957 | 219.40 | 85361.6225 | 114449.705 | 126636.8550 | 161873.28 |
| Menlo Park City Elementary | 175.0 | 98317.483029 | 27246.940768 | 16259.12 | 86321.9850 | 107683.840 | 118193.4350 | 138092.83 |
| Sequoia Union High | 463.0 | 97190.923866 | 31663.120873 | 2369.70 | 76728.0050 | 106057.000 | 121067.1750 | 152706.34 |
| San Mateo County Office of Education | 107.0 | 82472.189626 | 39042.438816 | 1442.17 | 61257.5350 | 101141.140 | 112090.6600 | 125511.89 |
| Belmont-Redwood Shores Elementary | 192.0 | 75600.078854 | 29794.200287 | 389.37 | 61106.5650 | 82535.865 | 100154.5525 | 120567.44 |
| Millbrae Elementary | 118.0 | 73237.939492 | 25669.150838 | 1129.65 | 59877.6925 | 82400.920 | 93143.4775 | 110617.36 |
| South San Francisco Unified | 475.0 | 71240.390589 | 23378.121732 | 3571.38 | 61071.0700 | 75791.690 | 89006.5850 | 123700.60 |
| Jefferson Elementary | 294.0 | 70895.214456 | 20457.987967 | 8.75 | 59641.2225 | 76396.025 | 86299.9850 | 104356.13 |
| Pacifica School District | 1.0 | 68010.680000 | NaN | 68010.68 | 68010.6800 | 68010.680 | 68010.6800 | 68010.68 |
| Burlingame Elementary | 168.0 | 67966.885774 | 23658.297316 | 124.49 | 52334.5025 | 72235.185 | 88342.0475 | 105432.58 |
| Las Lomitas Elementary | 140.0 | 66225.797357 | 52224.619640 | 121.74 | 4074.0750 | 76045.210 | 117819.3975 | 143552.72 |
| San Mateo-Foster City | 582.0 | 65746.562835 | 24875.457653 | 5265.89 | 47096.5850 | 72331.055 | 86252.9600 | 104866.65 |
| Jefferson Union High | 254.0 | 64031.084449 | 23561.854697 | 22.25 | 50859.1050 | 67971.275 | 81681.2000 | 121476.34 |
| Ravenswood City Elementary | 212.0 | 58770.823774 | 25177.607995 | 154.22 | 36492.7050 | 65393.615 | 77108.3975 | 100902.64 |
| Hillsborough City Elementary | 197.0 | 57593.772893 | 48096.593626 | 60.00 | 2617.6000 | 65825.390 | 106352.1000 | 136499.81 |
| Woodside Elementary | 69.0 | 56385.008116 | 49752.682222 | 159.06 | 2505.8000 | 57991.670 | 104225.3000 | 145463.08 |
| San Carlos Elementary | 229.0 | 56255.927991 | 39349.962461 | 43.71 | 9461.0900 | 68216.610 | 91471.2100 | 114395.08 |
| La Honda-Pescadero Unified | 37.0 | 53344.679459 | 27025.285021 | 2578.48 | 31291.4900 | 61565.280 | 70151.4500 | 97885.36 |
| Bayshore Elementary | 30.0 | 39795.116667 | 31961.471661 | 125.00 | 2765.6250 | 49401.620 | 65832.0200 | 95778.24 |
| count | mean | std | min | 25% | 50% | 75% | max | |
|---|---|---|---|---|---|---|---|---|
| Agency | ||||||||
| San Mateo Union High | 19.0 | 186014.068421 | 41554.803354 | 83340.30 | 172814.8900 | 187869.990 | 212029.5150 | 239112.31 |
| Menlo Park City Elementary | 9.0 | 165147.907778 | 23216.801901 | 140584.95 | 147325.8700 | 155081.060 | 180176.3100 | 200232.08 |
| San Mateo-Foster City | 33.0 | 160677.804242 | 44687.418499 | 43060.05 | 131534.8800 | 183233.330 | 191229.6700 | 205413.54 |
| Burlingame Elementary | 10.0 | 145156.330000 | 18097.761591 | 111612.22 | 133611.8700 | 143442.185 | 158919.0800 | 172007.33 |
| Portola Valley Elementary | 3.0 | 138096.876667 | 82832.511558 | 42479.98 | 113158.0300 | 183836.080 | 185905.3250 | 187974.57 |
| Pacifica School District | 10.0 | 135450.893000 | 29697.436489 | 79102.68 | 133327.4175 | 146118.630 | 153671.6425 | 162938.29 |
| Redwood City Elementary | 27.0 | 134345.885185 | 36362.904507 | 64276.06 | 117770.2150 | 146939.620 | 161811.7200 | 171994.80 |
| Belmont-Redwood Shores Elementary | 9.0 | 133671.777778 | 33199.366115 | 78340.00 | 116840.0000 | 147579.000 | 151459.0000 | 167230.00 |
| Las Lomitas Elementary | 5.0 | 133323.282000 | 40873.042355 | 64856.23 | 127825.3600 | 149181.400 | 158857.1400 | 165896.28 |
| San Carlos Elementary | 8.0 | 126029.747500 | 47083.167869 | 11095.54 | 134939.9025 | 138932.845 | 145274.4025 | 156567.63 |
| San Mateo County Office of Education | 6.0 | 120280.000000 | 68928.247948 | 307.00 | 93180.5000 | 156017.500 | 161391.7500 | 173920.00 |
| South San Francisco Unified | 21.0 | 118872.190476 | 44580.528660 | 0.00 | 72334.0000 | 141216.000 | 144639.0000 | 169704.00 |
| La Honda-Pescadero Unified | 3.0 | 96909.350000 | 40593.021953 | 50338.65 | 82966.0850 | 115593.520 | 120194.7000 | 124795.88 |
| Bayshore Elementary | 2.0 | 96493.500000 | 59352.421892 | 54525.00 | 75509.2500 | 96493.500 | 117477.7500 | 138462.00 |
| count | mean | std | min | 25% | 50% | 75% | max | |
|---|---|---|---|---|---|---|---|---|
| Agency | ||||||||
| San Mateo Union High | 19.0 | 177196.006316 | 50945.533308 | 83158.91 | 161453.3050 | 186167.560 | 213541.5150 | 239972.50 |
| San Mateo-Foster City | 32.0 | 169795.223125 | 31537.536297 | 82381.96 | 166983.1325 | 183739.540 | 188109.6950 | 197343.35 |
| Hillsborough City Elementary | 4.0 | 165782.157500 | 50980.912728 | 89546.44 | 163340.9650 | 188377.550 | 190818.7425 | 196827.09 |
| Woodside Elementary | 2.0 | 165410.615000 | 3362.851359 | 163032.72 | 164221.6675 | 165410.615 | 166599.5625 | 167788.51 |
| Las Lomitas Elementary | 6.0 | 143059.295000 | 50821.356825 | 64807.13 | 111643.4675 | 160733.300 | 176021.8100 | 195683.87 |
| San Carlos Elementary | 7.0 | 140336.004286 | 32989.198564 | 65947.53 | 150407.1350 | 151407.200 | 151861.6900 | 160459.65 |
| Burlingame Elementary | 9.0 | 137846.013333 | 43837.549136 | 60098.64 | 141060.9200 | 158731.970 | 163974.6800 | 171233.85 |
| Redwood City Elementary | 26.0 | 137550.526538 | 40295.257546 | 14975.72 | 132435.0925 | 151675.065 | 164450.6225 | 172164.09 |
| Menlo Park City Elementary | 10.0 | 135874.232000 | 56102.523391 | 55475.89 | 80450.5225 | 158968.130 | 171652.1050 | 200525.14 |
| Belmont-Redwood Shores Elementary | 10.0 | 133407.591000 | 55125.660838 | 1480.75 | 139859.2950 | 156494.035 | 165557.8025 | 171243.19 |
| Pacifica School District | 10.0 | 126106.621000 | 33906.266195 | 64211.49 | 104508.3675 | 141512.015 | 149916.9350 | 159419.51 |
| La Honda-Pescadero Unified | 3.0 | 123561.603333 | 5630.044762 | 118325.88 | 120584.0050 | 122842.130 | 126179.4650 | 129516.80 |
| Cabrillo Unified | 12.0 | 123013.089167 | 34362.644020 | 57603.29 | 96715.6525 | 139410.965 | 147405.4425 | 160910.12 |
| South San Francisco Unified | 24.0 | 121688.452083 | 35782.230750 | 37939.40 | 99966.2525 | 135713.240 | 144172.1000 | 173729.02 |
| Jefferson Elementary | 22.0 | 117413.223636 | 45141.946365 | 11055.74 | 77244.6450 | 140587.095 | 153125.3675 | 163498.60 |
| Millbrae Elementary | 9.0 | 89039.873333 | 42548.451478 | 48777.38 | 56596.1600 | 72040.820 | 134751.2400 | 151933.77 |
| Bayshore Elementary | 3.0 | 84482.180000 | 42568.925091 | 56680.98 | 59978.8650 | 63276.750 | 98382.7800 | 133488.81 |
| count | mean | std | min | 25% | 50% | 75% | max | |
|---|---|---|---|---|---|---|---|---|
| Agency | ||||||||
| Portola Valley Elementary | 2.0 | 192935.720000 | 13892.965336 | 183111.91 | 188023.8150 | 192935.720 | 197847.6250 | 202759.53 |
| Hillsborough City Elementary | 4.0 | 181961.687500 | 6793.991892 | 177599.65 | 178383.8650 | 179081.245 | 182659.0675 | 192084.61 |
| San Mateo Union High | 20.0 | 175506.898500 | 54568.536111 | 67855.19 | 163362.6800 | 200428.150 | 211421.2350 | 227395.26 |
| Las Lomitas Elementary | 4.0 | 164436.650000 | 26869.977225 | 128020.65 | 152222.7675 | 172468.990 | 184682.8725 | 184787.97 |
| Burlingame Elementary | 7.0 | 149433.510000 | 11250.878350 | 128525.62 | 144848.5350 | 154000.130 | 156008.3250 | 161795.10 |
| Menlo Park City Elementary | 9.0 | 140548.274444 | 34605.796984 | 86070.57 | 127400.9000 | 145263.680 | 169302.0400 | 183210.11 |
| San Mateo-Foster City | 36.0 | 138225.527500 | 45349.357500 | 3285.24 | 145835.8125 | 158053.275 | 163028.5125 | 174324.86 |
| Belmont-Redwood Shores Elementary | 8.0 | 131485.196250 | 29955.858061 | 62544.65 | 126116.7450 | 143240.910 | 149182.8700 | 153683.36 |
| Pacifica School District | 9.0 | 125850.023333 | 32904.557270 | 65012.77 | 113410.8200 | 138542.960 | 152575.9800 | 155341.13 |
| Redwood City Elementary | 31.0 | 124817.774839 | 40927.404876 | 21101.95 | 120327.9500 | 143169.990 | 155383.4400 | 159127.20 |
| San Carlos Elementary | 7.0 | 118769.937143 | 4486.343013 | 113406.66 | 116481.8200 | 117762.960 | 119962.9800 | 127330.34 |
| Ravenswood City Elementary | 11.0 | 118305.489091 | 27519.672571 | 64941.02 | 117154.1600 | 125356.900 | 135208.8850 | 148081.73 |
| La Honda-Pescadero Unified | 3.0 | 107645.756667 | 7726.013211 | 100878.14 | 103436.8700 | 105995.600 | 111029.5650 | 116063.53 |
| Jefferson Elementary | 21.0 | 107515.226667 | 41456.610446 | 28272.93 | 67263.1800 | 129369.740 | 140453.2100 | 153024.44 |
| Jefferson Union High | 16.0 | 103082.457500 | 47325.805624 | 18125.38 | 53597.0000 | 121242.095 | 140928.4550 | 162275.45 |
| San Bruno Park Elementary | 8.0 | 100421.731250 | 13315.892706 | 75014.08 | 98724.3300 | 103920.205 | 105636.3725 | 118816.79 |
| Millbrae Elementary | 10.0 | 78460.969000 | 55483.906718 | 328.69 | 42268.7625 | 70924.395 | 133340.2750 | 145329.18 |
| Brisbane Elementary | 4.0 | 58654.617500 | 48871.706135 | 2191.88 | 34216.5425 | 56474.425 | 80912.5000 | 119477.74 |
| count | mean | std | min | 25% | 50% | 75% | max | |
|---|---|---|---|---|---|---|---|---|
| Agency | ||||||||
| San Mateo Union High | 21.0 | 168199.121429 | 32821.681820 | 65133.59 | 164292.4000 | 178442.240 | 186531.4600 | 200312.54 |
| Menlo Park City Elementary | 7.0 | 165191.727143 | 19268.276390 | 143425.06 | 147228.3300 | 168641.040 | 180493.4300 | 188832.47 |
| Las Lomitas Elementary | 4.0 | 153098.130000 | 27567.402937 | 115571.82 | 141206.6550 | 159869.400 | 171760.8750 | 177081.90 |
| Woodside Elementary | 1.0 | 148332.620000 | NaN | 148332.62 | 148332.6200 | 148332.620 | 148332.6200 | 148332.62 |
| Portola Valley Elementary | 2.0 | 138273.290000 | 69583.139788 | 89070.58 | 113671.9350 | 138273.290 | 162874.6450 | 187476.00 |
| San Mateo-Foster City | 28.0 | 136210.376429 | 28504.820255 | 58301.25 | 134838.6900 | 148070.410 | 152265.9400 | 161376.83 |
| Hillsborough City Elementary | 6.0 | 136141.046667 | 43468.461304 | 82671.33 | 97315.2425 | 150507.790 | 165350.6250 | 183276.74 |
| Pacifica School District | 8.0 | 128275.500000 | 16281.787198 | 92122.77 | 124121.8850 | 132992.985 | 137476.8550 | 143420.10 |
| San Carlos Elementary | 6.0 | 124083.725000 | 29714.424867 | 63894.75 | 132580.8100 | 134533.980 | 136329.6200 | 142681.72 |
| Burlingame Elementary | 7.0 | 120261.875714 | 40205.770558 | 57829.58 | 97795.4450 | 144861.110 | 147052.1000 | 149447.35 |
| Jefferson Union High | 13.0 | 117395.471538 | 14348.549041 | 99867.86 | 105577.6500 | 118748.800 | 126963.1200 | 144346.76 |
| Sequoia Union High | 9.0 | 116424.277778 | 74029.746402 | 5816.90 | 67236.3900 | 97787.970 | 187083.7100 | 194906.81 |
| South San Francisco Unified | 24.0 | 116022.597083 | 21851.801554 | 54590.37 | 115257.2450 | 120079.995 | 126962.6825 | 149048.35 |
| Redwood City Elementary | 29.0 | 115146.415517 | 32121.290226 | 35858.30 | 98419.6100 | 124656.180 | 143859.6100 | 146224.08 |
| Bayshore Elementary | 2.0 | 114167.580000 | 1071.691038 | 113409.78 | 113788.6800 | 114167.580 | 114546.4800 | 114925.38 |
| Jefferson Elementary | 18.0 | 112871.017222 | 20143.728037 | 50362.61 | 110165.3650 | 120485.660 | 124816.5725 | 132074.02 |
| Ravenswood City Elementary | 10.0 | 106144.060000 | 29023.639506 | 59757.63 | 86772.7625 | 113974.130 | 126331.1825 | 138216.70 |
| Belmont-Redwood Shores Elementary | 11.0 | 104733.762727 | 33894.990068 | 66349.20 | 75004.3350 | 99767.030 | 138830.3100 | 148824.88 |
| Cabrillo Unified | 12.0 | 99055.687500 | 52119.047418 | 142.86 | 53397.7325 | 128833.920 | 137324.0850 | 146711.31 |
| Millbrae Elementary | 6.0 | 97533.555000 | 47175.443680 | 30219.41 | 63645.0600 | 125162.560 | 128733.3050 | 131594.02 |
| La Honda-Pescadero Unified | 2.0 | 89011.255000 | 705.897629 | 88512.11 | 88761.6825 | 89011.255 | 89260.8275 | 89510.40 |
| Brisbane Elementary | 2.0 | 66866.525000 | 66794.756120 | 19635.50 | 43251.0125 | 66866.525 | 90482.0375 | 114097.55 |
| count | mean | std | min | 25% | 50% | 75% | max | |
|---|---|---|---|---|---|---|---|---|
| Agency | ||||||||
| Portola Valley Elementary | 2.0 | 185965.170000 | 4859.930765 | 182528.68 | 184246.9250 | 185965.170 | 187683.4150 | 189401.66 |
| San Mateo Union High | 21.0 | 171357.172381 | 24137.915028 | 85650.28 | 163663.3100 | 177780.590 | 185413.5300 | 199114.42 |
| Sequoia Union High | 5.0 | 162846.766000 | 41521.194279 | 89080.97 | 175640.3000 | 178703.050 | 182101.4500 | 188708.06 |
| Woodside Elementary | 1.0 | 138713.160000 | NaN | 138713.16 | 138713.1600 | 138713.160 | 138713.1600 | 138713.16 |
| Menlo Park City Elementary | 7.0 | 126984.090000 | 34089.877175 | 77499.89 | 108304.2450 | 128353.260 | 147440.3200 | 171546.35 |
| San Carlos Elementary | 6.0 | 126075.578333 | 7312.113846 | 117097.57 | 122271.8700 | 125695.415 | 127506.1150 | 138724.70 |
| Hillsborough City Elementary | 6.0 | 116935.461667 | 49368.911092 | 60812.68 | 74829.1700 | 122644.730 | 160847.4650 | 163038.27 |
| Millbrae Elementary | 6.0 | 115742.036667 | 29603.364270 | 57249.90 | 116642.1450 | 128789.080 | 132284.2250 | 133581.72 |
| Belmont-Redwood Shores Elementary | 9.0 | 115626.123333 | 42328.176668 | 57996.80 | 75857.4000 | 135153.400 | 155856.3400 | 164687.35 |
| Burlingame Elementary | 7.0 | 115606.782857 | 40375.527838 | 53570.02 | 98662.9900 | 138601.410 | 139275.3000 | 141199.47 |
| Ravenswood City Elementary | 6.0 | 112550.943333 | 9433.165463 | 99067.27 | 106628.4975 | 112994.965 | 120048.8975 | 123341.91 |
| Jefferson Elementary | 17.0 | 109816.389412 | 20418.381634 | 37805.39 | 110570.2200 | 113140.540 | 121400.8900 | 124278.10 |
| Bayshore Elementary | 2.0 | 108843.265000 | 1063.594665 | 108091.19 | 108467.2275 | 108843.265 | 109219.3025 | 109595.34 |
| South San Francisco Unified | 23.0 | 106135.825652 | 28851.977980 | 47001.41 | 97468.8300 | 115824.620 | 125737.2050 | 143237.78 |
| San Mateo-Foster City | 28.0 | 101538.892500 | 29681.836713 | 34513.53 | 92152.3575 | 116813.640 | 120795.8325 | 128937.88 |
| Las Lomitas Elementary | 6.0 | 91682.333333 | 56234.660462 | 16877.43 | 61414.7275 | 81043.160 | 133932.0075 | 164696.71 |
| La Honda-Pescadero Unified | 3.0 | 85649.660000 | 23384.410704 | 60445.45 | 75153.6250 | 89861.800 | 98251.7650 | 106641.73 |
| Jefferson Union High | 20.0 | 78079.147500 | 27395.528533 | 40831.75 | 55991.7750 | 69575.035 | 103436.7450 | 117224.65 |